Excel Assignment I  Graphically Finding the roots of a cubic equationPurpose: Determine the roots of an equation graphically.Background: If f(x1)...

profile余曹

Excel Assignment I  Graphically Finding the roots of a cubic equationPurpose: Determine the roots of an equation graphically.Background: If f(x1) > 0 and f(x2) < 0   (or  f(x1) < 0 and f(x2) > 0 ) and f(x) is continuous, then the
intermediate value theorem insures that there is a solution (root)  f(x) = 0  such that   x1 <  xr  < x
Problem Statement:  Approximate the three roots of the cubic equation:  f(x) = 2x3  -  3x2 - 36x + 4  bygraphing f(x) with excel.  Approximate each root to within one decimal point.
Hints: All three roots are on the interval:   -4 < x < 6  .    Select x-axis scale so that you can graphicallyestimate the root values to within one decimal point accuracy.

    • 10 years ago
    • 5
    Answer(0)
    Bids(0)